CREATE EXTERNAL TABLE jms_dm.dm_trunk_error_scan_detail
(
    `waybill_no`        string COMMENT '运单号',
    `shipment_no`       string COMMENT '任务号',
    `scan_site_code`    string COMMENT '扫描站点code',
    `scan_site`         string COMMENT '扫描站点',
    `next_station_code` string COMMENT '下一站code',
    `next_station`      string COMMENT '下一站名字',
    `scan_type`         string COMMENT '扫描类型',
    `scan_user`         string COMMENT '扫描人员',
    `scan_time`         timestamp COMMENT '扫描时间',
    `shipment_sites_codes` array<string> COMMENT'任务号各个中心code'
)

COMMENT '干线错扫明细表'
    PARTITIONED BY (
  `dt` string COMMENT '分区字段-计划发车时间')
STORED AS parquet
LOCATION
  'hdfs://yl-bg-hdp/dw/hive/jms_dm.db/external/dm_trunk_error_scan_detail' ;